How to Copy Conditional Formatting to Another Workbook in Excel | 您所在的位置:网站首页 › vba copy to another workbook › How to Copy Conditional Formatting to Another Workbook in Excel |
Get FREE Advanced Excel Exercises with Solutions!
Conditional Formatting is one of the most used Excel tools. Conditional Formatting allows us to format cells according to our criteria. In this article, we will see several ways to Excel Copy Conditional Formatting to Another Workbook. We have a sample dataset containing Name, Gender, Occupation, and Salary. In our sample data Gender and Salary columns are conditional formatted. Here, Females are highlighted and Salary above $30000 is highlighted. We will see how to copy this formatting to another workbook, where we have another dataset That looks like the following image. We will see 3 easy methods to copy this Conditional Formatting in another workbook. Method 1: Copy Conditional Formatting to Another Workbook Using Format PainterHere, we will see the use of Format Painter. Steps: First, select the entire data set or the specific column or rows or cells where lies the formatting that you want to copy. Then, click the Format Painter.As you can see, the formatting is exactly what we wanted. Read More: How to Copy Conditional Formatting to Another Sheet (2 Quick Methods) Method 2: Copy Conditional Formatting to Another Workbook by Paste SpecialIn our second method, we will discuss Paste Special option to copy Conditional Formatting in Excel. Steps: First, select the specific range or cell where our conditional formatting lies. Then Press CTRL+C or copy using the right click of the mouse.All the cells are formatted accordingly. Read More: How to Remove Conditional Formatting but Keep the Format in Excel Similar Readings: Pivot Table Conditional Formatting Based on Another Column (8 Easy Ways) Conditional Formatting with INDEX-MATCH in Excel (4 Easy Formulas) Excel Conditional Formatting on Multiple Columns How to Do Conditional Formatting Highlight Row Based On Date Excel Conditional Formatting for Dates within 30 Days (3 Examples) Method 3: VBA to Copy Conditional Formatting to Another WorkbookAt the end of this article, we will see the use of VBA code to copy conditional formatting from one workbook to another. Keep in mind to open both the workbook while applying this method. Steps: First, right-click on the sheet and go to View Code.VBA code: Sub mycopycode() Workbooks("Copy Conditional Formatting").Worksheets("Sample Data").Activate Range("C5:C11", "E5:E11").Select Selection.Copy Workbooks("Book1").Worksheets("Sheet3").Activate Range("E4:E10", "G4:G10").Select Range("E4:E10", "G4:G10").PasteSpecial xlPasteFormats End SubThat’s it. Our VBA has copied the format to the new workbook. Read More: VBA Conditional Formatting Based on Another Cell Value in Excel Things to RememberWe have to keep a couple of things in mind while doing these methods. We have to check the Formula in conditional Formatting, whether it is Relative reference or Absolute reference. In case of referencing you may need to change the formula according to your cell after applying Paste Special of Format Painter. Always keep open the workbooks while copying from one workbook to another. ConclusionThese are 3 different methods to Copy Conditional Formatting to Another Workbook in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback Related Articles How to Apply Conditional Formatting to Multiple Rows (5 Ways) Do Conditional Formatting with Multiple Criteria (11 Ways) Conditional Formatting on Text that Contains Multiple Words in Excel Apply Conditional Formatting to Each Row Individually: 3 Tips Conditional Formatting Entire Column Based on Another Column(6 Steps) How to Find Highest Value in Excel Column (4 Methods) SaveSavedRemoved 0Tags: Excel Conditional Formatting Mahbubur Rahman is a highly skilled and experienced professional with a strong background in both engineering and business administration. With an impressive technical skill set and a passion for innovation and problem-solving, Mahbubur has achieved great success in his field. Related Articles Added to wishlistRemoved from wishlist 1 ![]() ![]() ![]() ![]() |
CopyRight 2018-2019 实验室设备网 版权所有 |